A hyperlink is a pointer from one object to another. The destination is frequently another Web page, but it can also be a picture, an e-mail address, a file (such as a multimedia file or Microsoft Office document), or a program. The hyperlink itself can be displayed as text or as a picture.
You can use hyperlinks to do the following:
Navigate to a file or Web page on a network, an intranet, or the Internet
Send an e-mail message
Start a file transfer, such as a download or an FTP process
When you point to text or a picture that contains a hyperlink, the pointer becomes a hand , indicating that it is something you can click. When a site visitor clicks the hyperlink, the destination is displayed, opened, or run, depending on the type of destination. For example, a hyperlink to a sound file opens the file in a media player, and a hyperlink to a Web page displays the page in a Web browser.
A hyperlink address can have up to four parts that are separated by the number sign (#):
Part | Description |
---|---|
displaytext | The text that you see in the field or control. For example, you might want to display a descriptive name for the World Wide Web site or object specified by the address and the subaddress. This is an optional field. |
address | An absolute or relative path to a target document. An absolute path is a fully qualified URL or UNC path to a document. |
subaddress | The location in the file or page. For example, you might want to point to a particular bookmark in a Word document. This is an optional field. |
screentip | The text that appears when you rest the pointer on a hyperlink. This is an optional field. |
In a field or text box that formats the hyperlink address as a hyperlink, Microsoft Access doesn't display all four parts in the field or control. If you want to see the whole hyperlink address, select the insertion point and press F2.
To jump to a location in this type of file |
Enter |
---|---|
Microsoft Word | A bookmark name |
Microsoft Excel | A defined name or a sheet!range. For example, type sheet1!A2 to jump to cell A2 in sheet 1. |
Microsoft PowerPoint | A slide number |
HTML document | A bookmark name (defined by using the NAME attribute of the <A> tag) |
Examples of hyperlink addresses
The following examples display the hyperlink address and what they point to. Note that URLs use forward slashes (/) and UNC paths use backward slashes (\).
Microsoft Corporation#http://www.microsoft.com#
The Microsoft home page on the Web. Displayed as "Microsoft Corporation."
#http://www.microsoft.com#
The Microsoft home page on the Web.
#http://www.microsoft.com#sample#
The Name tag called "sample" in the .htm document for the Microsoft home page. Name is an attribute of some tags in .htm pages.
#\\northwind\public\products.doc##List of discounted products
A Microsoft Word file called Products.doc in the public folder on the Northwind server. The ScreenTip is "List of discounted products."
Resume#c:\windows\personal \resume.doc#
A Word file called Resume.doc located in the C:\Windows\Personal folder. Displayed as "Resume."
#c:\windows\personal\resume.doc#
The same Resume.doc file located in the C:\Windows\Personal folder. The path name will be displayed because no display text is included.
#c:\windows\personal\resume.doc#Qualifications
The bookmark called "Qualifications" in the Resume.doc file.
To make it easier to enter a hyperlink address, Microsoft Access allows you to omit certain parts of an address. For example: